/*
 Navicat Premium Data Transfer

 Source Server         : xyb
 Source Server Type    : MySQL
 Source Server Version : 50735
 Source Host           : localhost:3306
 Source Schema         : materials_piyo

 Target Server Type    : MySQL
 Target Server Version : 50735
 File Encoding         : 65001

 Date: 17/11/2022 16:57:55
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for export_info
-- ----------------------------
DROP TABLE IF EXISTS `export_info`;
CREATE TABLE `export_info`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '入库信息编号',
  `material_id` int(11) NOT NULL COMMENT '物资基本信息id',
  `operate_location` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '出库地点',
  `applicants` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '出库申请人',
  `operator` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '经办人',
  `amount` int(11) NOT NULL COMMENT '数量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci;

-- ----------------------------
-- Records of export_info
-- ----------------------------
BEGIN;
INSERT INTO `export_info` (`id`, `material_id`, `operate_location`, `applicants`, `operator`, `amount`) VALUES (1, 3, '南通', '可莉', '纳西妲', 88), (2, 5, '南通', '甘雨', '迪卢克', 117), (3, 7, '苏州', '可莉', '纳西妲', 234), (4, 6, '苏州', '八重神子', '迪卢克', 71), (5, 10, '南通', '宵宫', '温迪', 182), (6, 10, '南通', '神里绫华', '迪卢克', 277), (7, 10, '无锡', '刻晴', '温迪', 63), (8, 4, '南京', '钟离', '迪卢克', 226), (9, 7, '无锡', '神里绫华', '迪卢克', 255), (10, 8, '南通', '可莉', '纳西妲', 281), (11, 6, '无锡', '八重神子', '纳西妲', 159), (12, 3, '南京', '胡桃', '纳西妲', 53), (13, 7, '苏州', '钟离', '温迪', 182), (14, 8, '无锡', '刻晴', '迪卢克', 120), (15, 6, '苏州', '神里绫华', '温迪', 191), (16, 6, '苏州', '八重神子', '温迪', 210), (17, 9, '南通', '刻晴', '迪卢克', 287), (18, 6, '南通', '甘雨', '迪卢克', 183), (19, 8, '南通', '刻晴', '纳西妲', 174), (20, 2, '南通', '钟离', '迪卢克', 108), (21, 7, '南京', '甘雨', '纳西妲', 198), (22, 1, '南通', '甘雨', '温迪', 163), (23, 9, '无锡', '甘雨', '纳西妲', 250), (24, 3, '苏州', '钟离', '温迪', 285), (25, 2, '无锡', '胡桃', '纳西妲', 295), (26, 4, '南通', '刻晴', '迪卢克', 83), (27, 10, '无锡', '刻晴', '纳西妲', 279), (28, 2, '无锡', '刻晴', '迪卢克', 277), (29, 10, '苏州', '钟离', '温迪', 116), (30, 9, '南京', '甘雨', '纳西妲', 199), (31, 10, '南京', '八重神子', '温迪', 244), (32, 5, '无锡', '刻晴', '温迪', 180), (33, 9, '南通', '可莉', '纳西妲', 59), (34, 9, '苏州', '可莉', '迪卢克', 187), (35, 5, '南京', '刻晴', '迪卢克', 251), (36, 9, '南京', '刻晴', '迪卢克', 191), (37, 2, '南京', '神里绫华', '温迪', 58), (38, 7, '苏州', '宵宫', '温迪', 224), (39, 6, '南通', '七七', '纳西妲', 101), (40, 10, '苏州', '宵宫', '迪卢克', 199), (41, 5, '苏州', '钟离', '纳西妲', 290), (42, 1, '南京', '七七', '迪卢克', 275), (43, 1, '无锡', '神里绫华', '纳西妲', 289), (44, 4, '无锡', '钟离', '纳西妲', 99), (45, 1, '南通', '宵宫', '温迪', 226), (46, 3, '无锡', '刻晴', '温迪', 129), (47, 1, '苏州', '七七', '迪卢克', 104), (48, 9, '南京', '甘雨', '迪卢克', 140), (49, 3, '南京', '胡桃', '迪卢克', 164), (50, 1, '苏州', '八重神子', '迪卢克', 287);
COMMIT;

-- ----------------------------
-- Table structure for import_info
-- ----------------------------
DROP TABLE IF EXISTS `import_info`;
CREATE TABLE `import_info`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '入库信息编号',
  `material_id` int(11) NOT NULL COMMENT '物资基本信息id',
  `operate_location` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '入库地点',
  `applicants` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '入库申请人',
  `operator` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '经办人',
  `amount` int(11) NOT NULL COMMENT '数量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci;

-- ----------------------------
-- Records of import_info
-- ----------------------------
BEGIN;
INSERT INTO `import_info` (`id`, `material_id`, `operate_location`, `applicants`, `operator`, `amount`) VALUES (1, 5, '苏州', '宵宫', '迪卢克', 354), (2, 10, '南京', '八重神子', '迪卢克', 546), (3, 6, '南通', '宵宫', '纳西妲', 359), (4, 4, '南京', '七七', '纳西妲', 589), (5, 3, '南京', '钟离', '迪卢克', 528), (6, 5, '苏州', '甘雨', '迪卢克', 537), (7, 4, '苏州', '钟离', '温迪', 332), (8, 8, '南京', '可莉', '纳西妲', 518), (9, 2, '南通', '神里绫华', '温迪', 259), (10, 1, '南京', '神里绫华', '温迪', 565), (11, 2, '南京', '神里绫华', '迪卢克', 453), (12, 6, '苏州', '八重神子', '纳西妲', 547), (13, 6, '无锡', '钟离', '温迪', 471), (14, 1, '苏州', '胡桃', '迪卢克', 357), (15, 7, '南通', '七七', '迪卢克', 534), (16, 3, '无锡', '钟离', '纳西妲', 283), (17, 9, '南京', '八重神子', '迪卢克', 240), (18, 8, '苏州', '神里绫华', '纳西妲', 381), (19, 6, '苏州', '神里绫华', '纳西妲', 483), (20, 7, '苏州', '宵宫', '温迪', 546), (21, 6, '无锡', '可莉', '迪卢克', 331), (22, 3, '南通', '宵宫', '温迪', 258), (23, 6, '南京', '可莉', '迪卢克', 493), (24, 1, '南京', '神里绫华', '温迪', 598), (25, 10, '南京', '甘雨', '迪卢克', 598), (26, 2, '苏州', '刻晴', '迪卢克', 536), (27, 1, '南京', '钟离', '迪卢克', 332), (28, 1, '苏州', '甘雨', '迪卢克', 280), (29, 8, '无锡', '刻晴', '温迪', 495), (30, 4, '南通', '神里绫华', '迪卢克', 313), (31, 2, '南京', '七七', '纳西妲', 539), (32, 7, '南通', '刻晴', '纳西妲', 293), (33, 10, '苏州', '刻晴', '纳西妲', 318), (34, 2, '南通', '神里绫华', '纳西妲', 324), (35, 9, '南通', '刻晴', '迪卢克', 333), (36, 10, '南京', '七七', '纳西妲', 262), (37, 8, '南京', '七七', '纳西妲', 513), (38, 9, '苏州', '刻晴', '迪卢克', 557), (39, 9, '无锡', '钟离', '温迪', 430), (40, 2, '苏州', '甘雨', '纳西妲', 405), (41, 10, '南通', '七七', '纳西妲', 228), (42, 5, '南京', '刻晴', '纳西妲', 372), (43, 10, '南通', '神里绫华', '温迪', 327), (44, 3, '无锡', '七七', '温迪', 503), (45, 4, '南通', '胡桃', '温迪', 320), (46, 3, '南京', '七七', '纳西妲', 309), (47, 10, '南京', '可莉', '纳西妲', 318), (48, 2, '南京', '胡桃', '温迪', 399), (49, 4, '无锡', '八重神子', '温迪', 344), (50, 1, '苏州', '胡桃', '迪卢克', 374);
COMMIT;

-- ----------------------------
-- Table structure for materials_basic_info
-- ----------------------------
DROP TABLE IF EXISTS `materials_basic_info`;
CREATE TABLE `materials_basic_info`  (
  `id` int(11) NOT NULL COMMENT '物资编号',
  `name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '物资名称',
  `specification` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '规格型号',
  `category` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '种类',
  `measure_unit` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '计量单位',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci;

-- ----------------------------
-- Records of materials_basic_info
-- ----------------------------
BEGIN;
INSERT INTO `materials_basic_info` (`id`, `name`, `specification`, `category`, `measure_unit`) VALUES (1, '口罩', '大胜KN95', '防疫物资', '包'), (2, '口罩', '睿铂PM2.5', '防疫物资', '包'), (3, '防护服', '杜邦', '防疫物资', '件'), (4, '酒精喷雾', '威露士', '防疫物资', '瓶'), (5, '核酸试管', '达安AGS8830', '医疗用品', '根'), (6, '桌子', 'AURORA震旦', '办公用品', '张'), (7, '中性笔', '晨光', '办公用品', '根'), (8, '方便面', '康师傅', '食品', '盒'), (9, '猪肉', NULL, '食品', '斤'), (10, '蔬菜包', NULL, '食品', '份');
COMMIT;

-- ----------------------------
-- Table structure for materials_remaining_info
-- ----------------------------
DROP TABLE IF EXISTS `materials_remaining_info`;
CREATE TABLE `materials_remaining_info`  (
  `id` int(11) NOT NULL COMMENT '物资编号',
  `remaining_amount` int(11) NOT NULL COMMENT '剩余数量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci;

-- ----------------------------
-- Records of materials_remaining_info
-- ----------------------------
BEGIN;
INSERT INTO `materials_remaining_info` (`id`, `remaining_amount`) VALUES (1, 1162), (2, 2177), (3, 1162), (4, 1490), (5, 425), (6, 1769), (7, 280), (8, 1332), (9, 247), (10, 1237);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
